CREATE TABLE "SALEOUTS" 
   (	"SERIAL_NO" VARCHAR2(20 BYTE), 
	"SELLIN_DATE" DATE, 
	"SELLOUT_DATE" DATE, 
	"WT_START_DATE" DATE, 
	"WT_END_DATE" DATE, 
	"SHOP_CODE" VARCHAR2(10 BYTE), 
	"SHOP_CELL" VARCHAR2(20 BYTE), 
	"SELLOUT_RESP_MSG" VARCHAR2(160 BYTE), 
	"POINT" VARCHAR2(10 BYTE), 
	"AMT" VARCHAR2(10 BYTE), 
	"SELLOUT_RESP_TYPE" VARCHAR2(10 BYTE), 
	"SELLOUT_TIME" VARCHAR2(8 BYTE), 
	"INCENTIVE_CFM_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"INCENTIVE_CFM_DATE" DATE, 
	"MODEL" VARCHAR2(50 BYTE), 
	"SUFFIX" VARCHAR2(20 BYTE), 
	"CLOSE_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"CLOSE_PERIOD" VARCHAR2(10 BYTE), 
	"SMS_YN" VARCHAR2(1 BYTE) DEFAULT 'Y', 
	"CREATE_DATE" DATE DEFAULT sysdate, 
	"INCENTIVE_CFM_USER" VARCHAR2(10 BYTE) DEFAULT 'SYS', 
	"CLOSE_USER" VARCHAR2(10 BYTE), 
	"INCENTIVE_CFM_PERIOD" VARCHAR2(12 BYTE), 
	"LAST_UPDATE_DATE" DATE DEFAULT sysdate, 
	"END_USER_CELL" VARCHAR2(20 BYTE), 
	"TRANSFER_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"TRANSFER_DATE" DATE, 
	"SO_TRANSFER_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N', 
	"SO_TRANSFER_DATE" DATE
   ) ;

    CREATE UNIQUE INDEX "SALEOUTS_PR_PK" ON "SALEOUTS" ("SERIAL_NO", "MODEL") ;


	 ALTER TABLE "SALEOUTS" ADD CONSTRAINT "SALEOUTS_PR_PK" PRIMARY KEY ("SERIAL_NO", "MODEL") ENABLE;
	  ALTER TABLE "SALEOUTS" MODIFY ("SHOP_CODE" NOT NULL ENABLE);
	  ALTER TABLE "SALEOUTS" MODIFY ("SERIAL_NO" NOT NULL ENABLE);
	  ALTER TABLE "SALEOUTS" MODIFY ("MODEL" NOT NULL ENABLE);
	  ALTER TABLE "SALEOUTS" MODIFY ("INCENTIVE_CFM_FLAG" NOT NULL ENABLE);
	  ALTER TABLE "SALEOUTS" MODIFY ("CREATE_DATE" NOT NULL ENABLE);


REM INSERTING into SALEOUTS
SET DEFINE OFF;
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212TWZH2J269',to_date('29-JAN-13','DD-MON-RR'),to_date('20-MAR-13','DD-MON-RR'),to_date('20-MAR-13','DD-MON-RR'),to_date('19-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1163$WF-S1015TT, Serial 212TWZH2J269$20/03/2013$25,000','0','25000','SO_SN_VL','143753','Y',to_date('20-MAR-13','DD-MON-RR'),'WF-S1015TT','ABWPLMH','Y','201304','Y',to_date('20-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('20-MAR-13','DD-MON-RR'),'84969988451','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNSM10398',to_date('30-JAN-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('18-MAR-14','DD-MON-RR'),'EASV0014','84949917778','1163$42LS4600, Serial 301VNSM10398$19/03/2013$40,000','0','40000','SO_SN_VL','145954','Y',to_date('19-MAR-13','DD-MON-RR'),'42LS4600','BTVWLJV','Y','201304','Y',to_date('19-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('19-MAR-13','DD-MON-RR'),'84962994479','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNVR06831',to_date('19-MAR-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('20-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNVR06831$21/03/2013$30,000','0','30000','SO_SN_VL','191859','Y',to_date('21-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('21-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('21-MAR-13','DD-MON-RR'),'841269705446','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNAX16240',to_date('26-FEB-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('20-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$47LM6200, Serial 301VNAX16240$21/03/2013$50,000','0','50000','SO_SN_VL','192148','Y',to_date('21-MAR-13','DD-MON-RR'),'47LM6200','ATV','Y','201304','Y',to_date('21-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('21-MAR-13','DD-MON-RR'),'84935083503','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNLZ03760',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3500, Serial 302VNLZ03760$22/03/2013$30,000','0','30000','SO_SN_VL','153457','Y',to_date('22-MAR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84902907138','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VWVR06791',to_date('24-JAN-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('22-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$WF-D8515DDD, Serial 211VWVR06791$23/03/2013$25,000','0','25000','SO_SN_VL','193610','Y',to_date('23-MAR-13','DD-MON-RR'),'WF-D8515DDD','ABWPEVN','Y','201304','Y',to_date('23-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('23-MAR-13','DD-MON-RR'),'84903162318','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INNG8W679',to_date('26-FEB-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('20-MAR-15','DD-MON-RR'),'EASV0009','84905383536','1161$M2341A-PT, Serial 301INNG8W679','0','0','SO_SN_VL','184327','Y',to_date('22-MAR-13','DD-MON-RR'),'M2341A-PT','ATVZ','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('22-MAR-13','DD-MON-RR'),'841215541626','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNFW0J523',to_date('24-JAN-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS3450, Serial 301VNFW0J523$22/03/2013$40,000','0','40000','SO_SN_VL','184404','Y',to_date('22-MAR-13','DD-MON-RR'),'42LS3450','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84908870488','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INNG086607',to_date('27-FEB-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1161$DP522, Serial 301INNG086607','0','0','SO_SN_VL','190534','Y',to_date('22-MAR-13','DD-MON-RR'),'DP522','BVNMLLK','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('22-MAR-13','DD-MON-RR'),'84988004450','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INLV3Q504',to_date('25-FEB-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('23-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1161$GN-185SS, Serial 301INLV3Q504','0','0','SO_SN_VL','161501','Y',to_date('24-MAR-13','DD-MON-RR'),'GN-185SS','APVPEVN','Y','201304','Y',to_date('24-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('24-MAR-13','DD-MON-RR'),'841648831611','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNNV01567',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS4600, Serial 303VNNV01567$22/03/2013$40,000','0','40000','SO_SN_VL','203420','Y',to_date('22-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84902079684','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNMU06675',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNMU06675$23/03/2013$30,000','0','30000','SO_SN_VL','184238','Y',to_date('23-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('23-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('23-MAR-13','DD-MON-RR'),'84905181879','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNPA08744',to_date('27-FEB-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS4600, Serial 302VNPA08744$26/03/2013$40,000','0','40000','SO_SN_VL','163012','Y',to_date('26-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('26-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('26-MAR-13','DD-MON-RR'),'84975382775','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302INMF2A667',to_date('08-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1163$GR-G702W, Serial 302INMF2A667$26/03/2013$50,000','0','50000','SO_SN_VL','164757','Y',to_date('26-MAR-13','DD-MON-RR'),'GR-G702W','ASVPEVN','Y','201304','Y',to_date('26-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('26-MAR-13','DD-MON-RR'),'841283663402','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNCL16155',to_date('26-FEB-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('26-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$47LM6200, Serial 301VNCL16155$27/03/2013$50,000','0','50000','SO_SN_VL','093937','Y',to_date('27-MAR-13','DD-MON-RR'),'47LM6200','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84914192172','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNYK06834',to_date('19-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('26-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNYK06834$27/03/2013$30,000','0','30000','SO_SN_VL','090030','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84975408478','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNUQ06846',to_date('19-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNUQ06846$27/03/2013$30,000','0','30000','SO_SN_VL','153044','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84934799488','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNVR06663',to_date('19-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('26-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNVR06663$27/03/2013$30,000','0','30000','SO_SN_VL','085954','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84975408478','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212KWTA0C161',to_date('08-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1163$WD-35600, Serial 212KWTA0C161$27/03/2013$50,000','0','50000','SO_SN_VL','164652','Y',to_date('27-MAR-13','DD-MON-RR'),'WD-35600','ASSPEVN','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'841283663402','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNGT06839',to_date('19-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNGT06839$27/03/2013$30,000','0','30000','SO_SN_VL','185841','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84907790254','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNGT06815',to_date('19-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNGT06815$27/03/2013$30,000','0','30000','SO_SN_VL','152920','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84934799488','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VWAX0H224',to_date('22-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('28-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1161$WF-C7217T, Serial 301VWAX0H224','0','0','SO_SN_VL','144332','Y',to_date('29-MAR-13','DD-MON-RR'),'WF-C7217T','ALGPEVN','Y','201304','Y',to_date('29-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('29-MAR-13','DD-MON-RR'),'841688366351','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INJL3C308',to_date('27-FEB-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('28-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GR-S362S, Serial 301INJL3C308$29/03/2013$25,000','0','25000','SO_SN_VL','184842','Y',to_date('29-MAR-13','DD-MON-RR'),'GR-S362S','ASVPEVN','Y','201304','Y',to_date('29-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('29-MAR-13','DD-MON-RR'),'84989391001','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNAX01472',to_date('27-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('28-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS4600, Serial 303VNAX01472$29/03/2013$40,000','0','40000','SO_SN_VL','191358','Y',to_date('29-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('29-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('29-MAR-13','DD-MON-RR'),'84914143736','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VWAX06856',to_date('26-FEB-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$WF-D8515DDD, Serial 211VWAX06856$01/04/2013$25,000','0','25000','SO_SN_VL','111715','Y',to_date('01-APR-13','DD-MON-RR'),'WF-D8515DDD','ABWPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84933031417','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNWP01041',to_date('13-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LS4600, Serial 303VNWP01041$01/04/2013$40,000','0','40000','SO_SN_VL','134923','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84903212642','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNSM0T598',to_date('19-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LM6200, Serial 302VNSM0T598$01/04/2013$40,000','0','40000','SO_SN_VL','135021','Y',to_date('01-APR-13','DD-MON-RR'),'42LM6200','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84904189478','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNPA02896',to_date('27-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3300, Serial 303VNPA02896$01/04/2013$30,000','0','30000','SO_SN_VL','111439','Y',to_date('01-APR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84914455455','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNNV01039',to_date('13-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LS4600, Serial 303VNNV01039$01/04/2013$40,000','0','40000','SO_SN_VL','135720','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),null,'Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNVR0G143',to_date('20-FEB-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1161$42CS460, Serial 302VNVR0G143','0','0','SO_SN_VL','135842','Y',to_date('01-APR-13','DD-MON-RR'),'42CS460','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('01-APR-13','DD-MON-RR'),'84902109109','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNMU08395',to_date('09-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1161$50PN4500, Serial 302VNMU08395','0','0','SO_SN_VL','135935','Y',to_date('01-APR-13','DD-MON-RR'),'50PN4500','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('01-APR-13','DD-MON-RR'),'84912402415','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNSM0B766',to_date('25-JAN-13','DD-MON-RR'),to_date('20-MAR-13','DD-MON-RR'),to_date('20-MAR-13','DD-MON-RR'),to_date('19-MAR-14','DD-MON-RR'),'EASV0014','84949917778','1163$32LS3450, Serial 301VNSM0B766$20/03/2013$30,000','0','30000','SO_SN_VL','163843','Y',to_date('20-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('20-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('20-MAR-13','DD-MON-RR'),'841682589467','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNRG05582',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3300, Serial 303VNRG05582$22/03/2013$30,000','0','30000','SO_SN_VL','101452','Y',to_date('22-MAR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84905498485','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNYK05562',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3300, Serial 303VNYK05562$22/03/2013$30,000','0','30000','SO_SN_VL','101545','Y',to_date('22-MAR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84905498485','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNXF05434',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3300, Serial 303VNXF05434$22/03/2013$30,000','0','30000','SO_SN_VL','101647','Y',to_date('22-MAR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84905498485','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNTD06457',to_date('20-MAR-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('22-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNTD06457$23/03/2013$30,000','0','30000','SO_SN_VL','192032','Y',to_date('23-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('23-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('23-MAR-13','DD-MON-RR'),'84905686179','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNJH0K412',to_date('19-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('23-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3500, Serial 302VNJH0K412$24/03/2013$30,000','0','30000','SO_SN_VL','145605','Y',to_date('24-MAR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('24-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('24-MAR-13','DD-MON-RR'),'84935027775','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNRG01670',to_date('19-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('26-MAR-13','DD-MON-RR'),to_date('25-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS4600, Serial 303VNRG01670$26/03/2013$40,000','0','40000','SO_SN_VL','122735','Y',to_date('26-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('26-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('26-MAR-13','DD-MON-RR'),'84905957744','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNXF02754',to_date('24-JAN-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('27-MAR-13','DD-MON-RR'),to_date('26-MAR-14','DD-MON-RR'),'EASV0024','84989199443','1163$32LS3500, Serial 301VNXF02754$27/03/2013$30,000','0','30000','SO_SN_VL','172322','Y',to_date('27-MAR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('27-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('27-MAR-13','DD-MON-RR'),'84976966035','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VWRG00974',to_date('22-MAR-13','DD-MON-RR'),to_date('28-MAR-13','DD-MON-RR'),to_date('28-MAR-13','DD-MON-RR'),to_date('27-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1161$WF-S8019SG, Serial 303VWRG00974','0','0','SO_SN_VL','143143','Y',to_date('28-MAR-13','DD-MON-RR'),'WF-S8019SG','APBPLVN','Y','201304','Y',to_date('28-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('28-MAR-13','DD-MON-RR'),'841678386119','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INYD3C218',to_date('27-FEB-13','DD-MON-RR'),to_date('28-MAR-13','DD-MON-RR'),to_date('28-MAR-13','DD-MON-RR'),to_date('27-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GR-S362S, Serial 301INYD3C218$28/03/2013$25,000','0','25000','SO_SN_VL','192713','Y',to_date('28-MAR-13','DD-MON-RR'),'GR-S362S','ASVPEVN','Y','201304','Y',to_date('28-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('28-MAR-13','DD-MON-RR'),'84979277325','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNXF0J354',to_date('24-JAN-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('28-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS3450, Serial 301VNXF0J354$29/03/2013$40,000','0','40000','SO_SN_VL','114144','Y',to_date('29-MAR-13','DD-MON-RR'),'42LS3450','ATV','Y','201304','Y',to_date('29-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('29-MAR-13','DD-MON-RR'),'841867184930','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNVR0K095',to_date('21-JAN-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('29-MAR-13','DD-MON-RR'),to_date('28-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS3450, Serial 301VNVR0K095$29/03/2013$40,000','0','40000','SO_SN_VL','191631','Y',to_date('29-MAR-13','DD-MON-RR'),'42LS3450','ATV','Y','201304','Y',to_date('29-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('29-MAR-13','DD-MON-RR'),'84989391001','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNMU00963',to_date('27-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS4600, Serial 303VNMU00963$01/04/2013$40,000','0','40000','SO_SN_VL','140548','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'841656737774','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNXF0T562',to_date('07-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LM6200, Serial 302VNXF0T562$01/04/2013$40,000','0','40000','SO_SN_VL','154132','Y',to_date('01-APR-13','DD-MON-RR'),'42LM6200','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84979701385','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNRG07550',to_date('13-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$32LS3450, Serial 303VNRG07550$01/04/2013$30,000','0','30000','SO_SN_VL','155238','Y',to_date('01-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84963343555','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNBB08093',to_date('07-FEB-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0023','84903411399','1163$42LS4600, Serial 302VNBB08093$01/04/2013$40,000','0','40000','SO_SN_VL','173043','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84978607451','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INPT3C312',to_date('27-FEB-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GR-S362S, Serial 301INPT3C312$01/04/2013$25,000','0','25000','SO_SN_VL','182342','Y',to_date('01-APR-13','DD-MON-RR'),'GR-S362S','ASVPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'841228569609','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301INQU3C316',to_date('27-FEB-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GR-S362S, Serial 301INQU3C316$01/04/2013$25,000','0','25000','SO_SN_VL','182556','Y',to_date('01-APR-13','DD-MON-RR'),'GR-S362S','ASVPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84914151777','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('209INZY3Z845',to_date('11-DEC-12','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('30-MAR-13','DD-MON-RR'),to_date('29-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GR-S502S, Serial 209INZY3Z845$01/04/2013$50,000','0','50000','SO_SN_VL','185211','Y',to_date('01-APR-13','DD-MON-RR'),'GR-S502S','ASVPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84963055084','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212TWAT2L384',to_date('23-JAN-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('30-MAR-14','DD-MON-RR'),'EASV0020','84976334705','1163$WD-8600, Serial 212TWAT2L384$01/04/2013$25,000','0','25000','SO_SN_VL','095022','Y',to_date('01-APR-13','DD-MON-RR'),'WD-8600','ABWPLMH','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84985456837','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212VNMU04219',to_date('15-JAN-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('30-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$47LM6200, Serial 212VNMU04219$01/04/2013$50,000','0','50000','SO_SN_VL','134114','Y',to_date('01-APR-13','DD-MON-RR'),'47LM6200','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84914278111','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VWUQ06806',to_date('26-FEB-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('31-MAR-13','DD-MON-RR'),to_date('30-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$WF-D8515DDD, Serial 211VWUQ06806$01/04/2013$25,000','0','25000','SO_SN_VL','202757','Y',to_date('01-APR-13','DD-MON-RR'),'WF-D8515DDD','ABWPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84913463653','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNAX02552',to_date('13-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LM5800, Serial 303VNAX02552$01/04/2013$40,000','0','40000','SO_SN_VL','140942','Y',to_date('01-APR-13','DD-MON-RR'),'42LM5800','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84944046881','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNLZ01032',to_date('13-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LS4600, Serial 303VNLZ01032$01/04/2013$40,000','0','40000','SO_SN_VL','141337','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'841685333888','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNKE01037',to_date('13-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LS4600, Serial 303VNKE01037$01/04/2013$40,000','0','40000','SO_SN_VL','142821','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84989993935','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212VNMU0K043',to_date('10-JAN-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$32LS3500, Serial 212VNMU0K043$01/04/2013$30,000','0','30000','SO_SN_VL','144656','Y',to_date('01-APR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84979883703','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNSM0H870',to_date('22-FEB-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$42LS4600, Serial 302VNSM0H870$01/04/2013$40,000','0','40000','SO_SN_VL','144805','Y',to_date('01-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84904205926','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNZC04421',to_date('24-JAN-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1163$32LS3500, Serial 301VNZC04421$01/04/2013$30,000','0','30000','SO_SN_VL','144854','Y',to_date('01-APR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84904456885','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302INMF3D939',to_date('22-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1163$GN-205SS, Serial 302INMF3D939$01/04/2013$25,000','0','25000','SO_SN_VL','181804','Y',to_date('01-APR-13','DD-MON-RR'),'GN-205SS','APVPEVN','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84976351575','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNUQ03206',to_date('15-JAN-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$47LM6200, Serial 301VNUQ03206$01/04/2013$50,000','0','50000','SO_SN_VL','195213','Y',to_date('01-APR-13','DD-MON-RR'),'47LM6200','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84918442309','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNRG06062',to_date('09-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0074','84946833933','1163$32LS3450, Serial 303VNRG06062$02/04/2013$30,000','0','30000','SO_SN_VL','010053','Y',to_date('02-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'841652220929','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302INPT06560',to_date('26-FEB-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('23-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1161$GN-155SS, Serial 302INPT06560','0','0','SO_SN_VL','160140','Y',to_date('24-MAR-13','DD-MON-RR'),'GN-155SS','APVPEVN','Y','201304','Y',to_date('24-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('24-MAR-13','DD-MON-RR'),'84975848685','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNPA10920',to_date('26-JAN-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('23-MAR-13','DD-MON-RR'),to_date('22-MAR-14','DD-MON-RR'),'EASV0014','84949917778','1163$42LS4600, Serial 301VNPA10920$25/03/2013$40,000','0','40000','SO_SN_VL','161812','Y',to_date('25-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('25-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('25-MAR-13','DD-MON-RR'),'84962994479','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNRG02062',to_date('11-JAN-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('18-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1163$32LS3300, Serial 301VNRG02062$19/03/2013$30,000','0','30000','SO_SN_VL','160004','Y',to_date('19-MAR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('19-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('19-MAR-13','DD-MON-RR'),'841665030149','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VWXF09978',to_date('26-JAN-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('19-MAR-13','DD-MON-RR'),to_date('18-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1163$WF-S8019SG, Serial 301VWXF09978$19/03/2013$10,000','0','10000','SO_SN_VL','175801','Y',to_date('19-MAR-13','DD-MON-RR'),'WF-S8019SG','APBPLVN','Y','201304','Y',to_date('19-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('19-MAR-13','DD-MON-RR'),'841203829908','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('209INSE16334',to_date('08-OCT-12','DD-MON-RR'),to_date('25-MAR-13','DD-MON-RR'),to_date('25-MAR-13','DD-MON-RR'),to_date('24-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$GN-255PG, Serial 209INSE16334$25/03/2013$25,000','0','25000','SO_SN_VL','163523','Y',to_date('25-MAR-13','DD-MON-RR'),'GN-255PG','APGPEVN','Y','201304','Y',to_date('25-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('25-MAR-13','DD-MON-RR'),'841697686795','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNFW06851',to_date('19-MAR-13','DD-MON-RR'),to_date('25-MAR-13','DD-MON-RR'),to_date('25-MAR-13','DD-MON-RR'),to_date('24-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3450, Serial 303VNFW06851$25/03/2013$30,000','0','30000','SO_SN_VL','160031','Y',to_date('25-MAR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('25-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('25-MAR-13','DD-MON-RR'),'84583541136','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNEY0G548',to_date('25-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0068','84943360174','1161$47LN5400, Serial 303VNEY0G548','0','0','SO_SN_VL','142542','Y',to_date('01-APR-13','DD-MON-RR'),'47LN5400','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('01-APR-13','DD-MON-RR'),'84936948879','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNNV0K431',to_date('27-MAR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('01-APR-13','DD-MON-RR'),to_date('31-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3500, Serial 302VNNV0K431$01/04/2013$30,000','0','30000','SO_SN_VL','193129','Y',to_date('01-APR-13','DD-MON-RR'),'32LS3500','ATV','Y','201304','Y',to_date('01-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('01-APR-13','DD-MON-RR'),'84983318002','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('209HAER00452',to_date('22-NOV-12','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0027','84945379378','1161$V10EN1N, Serial 209HAER00452','0','0','SO_SN_VL','142537','Y',to_date('02-APR-13','DD-MON-RR'),'V10EN1N','AMBBEVN','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('02-APR-13','DD-MON-RR'),'841698763699','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNTD07009',to_date('22-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNTD07009$02/04/2013$30,000','0','30000','SO_SN_VL','153741','Y',to_date('02-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'84943055997','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNZC12773',to_date('31-JAN-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0020','84976334705','1161$32CS410, Serial 301VNZC12773','0','0','SO_SN_VL','155308','Y',to_date('02-APR-13','DD-MON-RR'),'32CS410','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('02-APR-13','DD-MON-RR'),'84987689686','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212TWQW2L300',to_date('23-JAN-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0020','84976334705','1163$WD-8600, Serial 212TWQW2L300$02/04/2013$25,000','0','25000','SO_SN_VL','155402','Y',to_date('02-APR-13','DD-MON-RR'),'WD-8600','ABWPLMH','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'84989437906','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNWP11825',to_date('30-JAN-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1161$42CS460, Serial 301VNWP11825','0','0','SO_SN_VL','155904','Y',to_date('02-APR-13','DD-MON-RR'),'42CS460','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('02-APR-13','DD-MON-RR'),'841679274882','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNRG06926',to_date('22-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNRG06926$02/04/2013$30,000','0','30000','SO_SN_VL','160006','Y',to_date('02-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'84943929115','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNKE02333',to_date('28-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$42LS4600, Serial 303VNKE02333$02/04/2013$40,000','0','40000','SO_SN_VL','160139','Y',to_date('02-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'841698584710','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301PNWK8S841',to_date('05-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$WD-7800, Serial 301PNWK8S841$02/04/2013$25,000','0','25000','SO_SN_VL','163537','Y',to_date('02-APR-13','DD-MON-RR'),'WD-7800','ABWPEVN','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'841244525255','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNEY07084',to_date('11-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNEY07084$02/04/2013$30,000','0','30000','SO_SN_VL','153613','Y',to_date('02-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'84987219990','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNSM07078',to_date('11-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNSM07078$02/04/2013$30,000','0','30000','SO_SN_VL','160313','Y',to_date('02-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'841643600694','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VWLZ00512',to_date('14-DEC-12','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1161$WD-9990TDS, Serial 211VWLZ00512','0','0','SO_SN_VL','164158','Y',to_date('02-APR-13','DD-MON-RR'),'WD-9990TDS','ABWPLVN','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('02-APR-13','DD-MON-RR'),'84916120702','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNAX0K088',to_date('21-JAN-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LS3450, Serial 301VNAX0K088$02/04/2013$40,000','0','40000','SO_SN_VL','193207','Y',to_date('02-APR-13','DD-MON-RR'),'42LS3450','ATV','Y','201304','Y',to_date('02-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('02-APR-13','DD-MON-RR'),'84905963127','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301TWXD4B858',to_date('04-MAR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('02-APR-13','DD-MON-RR'),to_date('01-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$WD-8600, Serial 301TWXD4B858$03/04/2013$25,000','0','25000','SO_SN_VL','172351','Y',to_date('03-APR-13','DD-MON-RR'),'WD-8600','ABWPLMH','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'84972260061','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNPA07456',to_date('13-MAR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0068','84943360174','1163$32LS3450, Serial 303VNPA07456$03/04/2013$30,000','0','30000','SO_SN_VL','100046','Y',to_date('03-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'84912302368','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VNJH00236',to_date('14-DEC-12','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0017','84915585565','1161$26LS3300, Serial 211VNJH00236','0','0','SO_SN_VL','135136','Y',to_date('03-APR-13','DD-MON-RR'),'26LS3300','ATV','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('03-APR-13','DD-MON-RR'),'84982834034','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('211VWQS04684',to_date('17-NOV-12','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0018','841652342297','1161$WD-14600, Serial 211VWQS04684','0','0','SO_SN_VL','150404','Y',to_date('03-APR-13','DD-MON-RR'),'WD-14600','ABWPLVN','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('03-APR-13','DD-MON-RR'),'84912918144','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNWP16337',to_date('05-FEB-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0018','841652342297','1163$47LM6200, Serial 301VNWP16337$03/04/2013$50,000','0','50000','SO_SN_VL','151539','Y',to_date('03-APR-13','DD-MON-RR'),'47LM6200','ATV','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'841276705772','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303INVM0N727',to_date('30-MAR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0053','84913457377','1161$GN-185SS, Serial 303INVM0N727','0','0','SO_SN_VL','155120','Y',to_date('03-APR-13','DD-MON-RR'),'GN-185SS','APVPEVN','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('03-APR-13','DD-MON-RR'),'84936483534','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('210INLV2R816',to_date('22-JAN-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0062','84903579131','1161$GN-185PG, Serial 210INLV2R816','0','0','SO_SN_VL','155322','Y',to_date('03-APR-13','DD-MON-RR'),'GN-185PG','APGPEVN','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('03-APR-13','DD-MON-RR'),'841626517535','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNWP0S897',to_date('29-JAN-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0017','84915585565','1163$42LS4600, Serial 301VNWP0S897$03/04/2013$40,000','0','40000','SO_SN_VL','163745','Y',to_date('03-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'84982834034','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('302VNEY0S612',to_date('05-MAR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$42LS4600, Serial 302VNEY0S612$03/04/2013$40,000','0','40000','SO_SN_VL','170833','Y',to_date('03-APR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'84987776372','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212TWNM2C495',to_date('18-JAN-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('03-APR-13','DD-MON-RR'),to_date('02-APR-14','DD-MON-RR'),'EASV0068','84904079188','1163$WD-10600, Serial 212TWNM2C495$03/04/2013$25,000','0','25000','SO_SN_VL','173456','Y',to_date('03-APR-13','DD-MON-RR'),'WD-10600','ABWPLMH','Y','201304','Y',to_date('03-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('03-APR-13','DD-MON-RR'),'84972252171','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNDN07058',to_date('28-MAR-13','DD-MON-RR'),to_date('04-APR-13','DD-MON-RR'),to_date('04-APR-13','DD-MON-RR'),to_date('03-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNDN07058$04/04/2013$30,000','0','30000','SO_SN_VL','084608','Y',to_date('04-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('04-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('04-APR-13','DD-MON-RR'),'84914761170','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNGT06983',to_date('28-MAR-13','DD-MON-RR'),to_date('04-APR-13','DD-MON-RR'),to_date('04-APR-13','DD-MON-RR'),to_date('03-APR-14','DD-MON-RR'),'EASV0021','841658336006','1163$32LS3450, Serial 303VNGT06983$04/04/2013$30,000','0','30000','SO_SN_VL','085613','Y',to_date('04-APR-13','DD-MON-RR'),'32LS3450','ATV','Y','201304','Y',to_date('04-APR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('04-APR-13','DD-MON-RR'),'84914761170','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNGT05567',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$32LS3300, Serial 303VNGT05567$22/03/2013$30,000','0','30000','SO_SN_VL','101730','Y',to_date('22-MAR-13','DD-MON-RR'),'32LS3300','ATV','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('22-MAR-13','DD-MON-RR'),'84905498485','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('212INSEOC950',to_date('03-DEC-12','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0017','84915585565','1161$GN-155SS, Serial 212INSEOC950','0','0','SO_SN_VL','154640','Y',to_date('22-MAR-13','DD-MON-RR'),'GN-155SS','APVPEVN','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('22-MAR-13','DD-MON-RR'),'84909644556','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303INFK0N723',to_date('19-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('22-MAR-13','DD-MON-RR'),to_date('21-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1161$GN-185SS, Serial 303INFK0N723','0','0','SO_SN_VL','184509','Y',to_date('22-MAR-13','DD-MON-RR'),'GN-185SS','APVPEVN','Y','201304','Y',to_date('22-MAR-13','DD-MON-RR'),'SYS','VN101025','NA',to_date('22-MAR-13','DD-MON-RR'),'84905583018','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('303VNFW0C059',to_date('20-MAR-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('21-MAR-13','DD-MON-RR'),to_date('20-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$42LM5800, Serial 303VNFW0C059$21/03/2013$40,000','0','40000','SO_SN_VL','140521','Y',to_date('21-MAR-13','DD-MON-RR'),'42LM5800','ATV','Y','201304','Y',to_date('21-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('21-MAR-13','DD-MON-RR'),'84906407016','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNFW0D939',to_date('21-JAN-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('23-MAR-14','DD-MON-RR'),'EASV0009','84905383536','1163$47LS4600, Serial 301VNFW0D939$24/03/2013$50,000','0','50000','SO_SN_VL','082832','Y',to_date('24-MAR-13','DD-MON-RR'),'47LS4600','ATV','Y','201304','Y',to_date('24-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('24-MAR-13','DD-MON-RR'),'84905957744','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
Insert into SALEOUTS (SERIAL_NO,SELLIN_DATE,SELLOUT_DATE,WT_START_DATE,WT_END_DATE,SHOP_CODE,SHOP_CELL,SELLOUT_RESP_MSG,POINT,AMT,SELLOUT_RESP_TYPE,SELLOUT_TIME,INCENTIVE_CFM_FLAG,INCENTIVE_CFM_DATE,MODEL,SUFFIX,CLOSE_FLAG,CLOSE_PERIOD,SMS_YN,CREATE_DATE,INCENTIVE_CFM_USER,CLOSE_USER,INCENTIVE_CFM_PERIOD,LAST_UPDATE_DATE,END_USER_CELL,TRANSFER_FLAG,TRANSFER_DATE,SO_TRANSFER_FLAG,SO_TRANSFER_DATE) values ('301VNHJ0S785',to_date('25-JAN-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('24-MAR-13','DD-MON-RR'),to_date('23-MAR-14','DD-MON-RR'),'EASV0036','84984651208','1163$42LS4600, Serial 301VNHJ0S785$24/03/2013$40,000','0','40000','SO_SN_VL','163104','Y',to_date('24-MAR-13','DD-MON-RR'),'42LS4600','ATV','Y','201304','Y',to_date('24-MAR-13','DD-MON-RR'),'SYS','VN101025','001303180418',to_date('24-MAR-13','DD-MON-RR'),'84975375253','Y',to_date('21-NOV-13','DD-MON-RR'),'Y',to_date('05-JUL-14','DD-MON-RR'));
